﻿CREATE TABLE [flcr].[PROJECT_SCHEDULE] (
    [PROJ_PLAN_ID]           INT           IDENTITY (1, 1) NOT NULL,
    [AUDIT_USER]             VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]             DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]          INT           NOT NULL,
    [AUDIT_MOD_USER]         VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]         DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]      INT           NOT NULL,
    [ACTIVE_FLG]             BIT           NOT NULL,
    [MILESTONE_FLG]          BIT           NOT NULL,
    [EFFORT_DRIVEN]          BIT           NOT NULL,
    [TASK_TYPE]              INT           NOT NULL,
    [TASK_NAME]              VARCHAR (100) NOT NULL,
    [DURATION]               VARCHAR (100) NOT NULL,
    [DURATION_MEASURE]       INT           NOT NULL,
    [DURATION_ESTIMATED_FLG] BIT           NOT NULL,
    [START]                  DATETIME      NOT NULL,
    [FINISH]                 DATETIME      NOT NULL,
    [COMPLETE_PCT]           INT           NOT NULL,
    [WBS_ID]                 INT           NOT NULL,
    [ACCT_LEDGER_ID]         INT           NOT NULL,
    [PARENT_ID]              INT           NULL
);

